Transcription: You need to include an absolute reference to the cell containing the commission percentage in the commission formula. Let's enter the formula in cell I5 and use the F4 key to make the cell reference absolute. Press the Enter key to begin.